How to: Create an absolute reference in a formula.
Solution:
Type a dollar sign ($) in front of the column letter and the row number of the cell references.
1) Select the cell containing the formula to edit.
2) Press F2. (The insertion point appears at the end of the formula.)
3) Move the insertion point before the reference to be edited.
NOTE: By default, cell and range references typed in a formula are relative. A relative reference adjusts automatically when the related formula is moved or copied. After a reference is changed to absolute, however, the reference remains fixed when the related formula is moved or copied.
4) Type a dollar sign ($) in front of the column letter AND the row number of the reference.
EXAMPLE: The absolute reference for 'D4' is '$D$4'.
5) Press ENTER.
6) Repeat steps 1) through 5) for absolute references in another cell.
